/**
 * Copyright 2005 The Apache Software Foundation
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.edi.db.type;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.sql.Types;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;

import com.edi.db.cfg.Environment;

public class CalendarType extends NullableType {
	public void set(PreparedStatement st, Object value, int index)
			throws SQLException {
		final Calendar cal = (Calendar) value;
		// st.setTimestamp( index, new Timestamp( cal.getTimeInMillis() ), cal
		// ); //JDK 1.5 only
		st.setTimestamp(index, new Timestamp(cal.getTime().getTime()), cal);
	}

	public int sqlType() {
		return Types.TIMESTAMP;
	}

	public Class getReturnedClass() {
		return Calendar.class;
	}

	public String getName() {
		return "calendar";
	}

	public boolean isEqual(Object x, Object y) {
		if (x == y)
			return true;
		if (x == null || y == null)
			return false;

		Calendar calendar1 = (Calendar) x;
		Calendar calendar2 = (Calendar) y;

		return calendar1.get(Calendar.MILLISECOND) == calendar2
				.get(Calendar.MILLISECOND)
				&& calendar1.get(Calendar.SECOND) == calendar2
						.get(Calendar.SECOND)
				&& calendar1.get(Calendar.MINUTE) == calendar2
						.get(Calendar.MINUTE)
				&& calendar1.get(Calendar.HOUR_OF_DAY) == calendar2
						.get(Calendar.HOUR_OF_DAY)
				&& calendar1.get(Calendar.DAY_OF_MONTH) == calendar2
						.get(Calendar.DAY_OF_MONTH)
				&& calendar1.get(Calendar.MONTH) == calendar2
						.get(Calendar.MONTH)
				&& calendar1.get(Calendar.YEAR) == calendar2.get(Calendar.YEAR);
	}

	public Object get(ResultSet rs, String name) throws SQLException {

		Timestamp ts = rs.getTimestamp(name);
		if (ts != null) {
			Calendar cal = new GregorianCalendar();
			if (Environment.jvmHasTimestampBug()) {
				cal.setTime(new Date(ts.getTime() + ts.getNanos() / 1000000));
			} else {
				cal.setTime(ts);
			}
			return cal;
		} else {
			return null;
		}

	}
	
	@Override
	public String getTypeValue(Object value) {
		// TODO Auto-generated method stub
		return String.valueOf(value);
	}
}
